import pandas as pd
# 主键合并
data_order = pd.read_excel(r'../data/新订单表.xlsx')
data_detail = pd.read_excel(r'../data/新明细表.xlsx')

data1 = data_order.loc[:1, :]  # 只有2 行的订单表
data2 = data_detail[['订单编号', '菜名']]  # 只有两列的明细表
print(data1)
print(data2)
merge = pd.merge(
    data1,
    data2,
    how='left',  # 合并方式
    on='订单编号'  # 主键

)

print(merge)